- 01. Intro
- 02. Aggregation Functions
- 03. Aggregation Functions
- 04. Logical Functions: IF
- 05. Quiz: Comparison Operators
- 06. Logical Functions: AND, OR, NOT
- 07. Quiz: Logical Functions
- 08. Conditional Aggregation Functions
- 09. Exercise: COUNTIF, SUMIF
- 10. Pivot Tables
- 11. Exercise: Pivot Tables
- 12. Named Ranges
- 13. Named Ranges
- 14. Lookup Functions
- 15. Exercise: VLOOKUP
- 16. Recap